const mysql=require('mysql')

var con=mysql.createConnection({
    host:'192.168.187.144',
    port:3306,
    user:'root',
    password:'ddd',
    database:'mydatabase'
})

var obj={}

obj.query=async function(sqlStr,arr){
    return await new Promise((resolve,reject)=>{
        con.query(sqlStr,arr,(err,result)=>{
            if(err){
                reject(err)
            }
            else{
                resolve(result)
            }
        })
    })
    
}

module.exports=obj